[dbo].[TagRelatedName]

Property	Value
Created	10:31:40 AM Tuesday, March 02, 2010
Last Modified	11:40:09 AM Monday, February 20, 2012

Property

Value

Created

10:31:40 AM Tuesday, March 02, 2010

Last Modified

11:40:09 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_TagRelatedName: TagKey\RelatedName$	TagKey	uniqueidentifier	16
$Cluster Primary Key PK_TagRelatedName: TagKey\RelatedName$	RelatedName	nvarchar(100)	200
	TagRelationshipTypeCode	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_TagRelatedName: TagKey\RelatedName$

TagKey

uniqueidentifier

$Cluster Primary Key PK_TagRelatedName: TagKey\RelatedName$

RelatedName

nvarchar(100)

200

TagRelationshipTypeCode

int

	Name	Columns	Unique
$Cluster Primary Key PK_TagRelatedName: TagKey\RelatedName$	PK_TagRelatedName	TagKey, RelatedName
	IX_TagRelatedName_RelatedName	RelatedName

Name

Columns

Unique

$Cluster Primary Key PK_TagRelatedName: TagKey\RelatedName$

PK_TagRelatedName

TagKey, RelatedName

IX_TagRelatedName_RelatedName

RelatedName

Name	Columns
FK_TagRelatedName_Tag	TagKey->[dbo].[Tag].[TagKey]
FK_TagRelatedName_TagRelationshipTypeRef	TagRelationshipTypeCode->[dbo].[TagRelationshipTypeRef].[TagRelationshipTypeCode]

Name

Columns

FK_TagRelatedName_Tag

TagKey->[dbo].[Tag].[TagKey]

FK_TagRelatedName_TagRelationshipTypeRef

TagRelationshipTypeCode->[dbo].[TagRelationshipTypeRef].[TagRelationshipTypeCode]

SQL Script

CREATE TABLE [dbo].[TagRelatedName]
(
[TagKey] [uniqueidentifier] NOT NULL,
[RelatedName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TagRelationshipTypeCode] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[TagRelatedName] ADD CONSTRAINT [PK_TagRelatedName] PRIMARY KEY CLUSTERED ([TagKey], [RelatedName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_TagRelatedName_RelatedName] ON [dbo].[TagRelatedName] ([RelatedName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TagRelatedName] ADD CONSTRAINT [FK_TagRelatedName_Tag] FOREIGN KEY ([TagKey]) REFERENCES [dbo].[Tag] ([TagKey])
GO
ALTER TABLE [dbo].[TagRelatedName] ADD CONSTRAINT [FK_TagRelatedName_TagRelationshipTypeRef] FOREIGN KEY ([TagRelationshipTypeCode]) REFERENCES [dbo].[TagRelationshipTypeRef] ([TagRelationshipTypeCode])
GO